ActiveReports 12
Drilldown Reports
ActiveReports 12 > ActiveReports User Guide > Samples and Walkthroughs > Walkthroughs > Page Report/RDL Report Walkthroughs > Preview > Drilldown Reports

This walkthrough expands upon the report created in the Master Detail Reports walkthrough. If you have not created the Master Detail report (CustomerOrders.rdlx) already, please do so before continuing.

This walkthrough illustrates how to create a drilldown report using the Hidden and ToggleItem properties.

The walkthrough is split up into the following activities:

Note: This walkthrough uses the Customer table from the Reels database. By default, in ActiveReports, the Reels.mdb file is located in the [User Documents folder]\GrapeCity Samples\ActiveReports 12\Data folder.

When you complete this walkthrough you get a layout that looks similar to the following at run time.

Design-Time Layout

Run-Time Layout

To open the report in Visual Studio

  1. Open the Master Detail Report project in Visual Studio.
  2. In the Visual Studio Solution Explorer, double-click CustomerOrders.rdlx.

To hide table rows and set a toggle item

  1. In the designer, click inside the table to display the column and row handles along the top and left sides of the table.
  2. Select the second group header row containing the static labels (Title, QuantityPrice and Total) by clicking the row handle to the left of it.
  3. Hold the CTRL key and select the Detail row containing field expressions to add to the selection.
  4. In the Properties window, expand the Visibility property and set its properties as follows.
    Property Name Property Value
    Visibility Hidden True
    Visibility Toggle Item TextBox10 (the textbox containing the expression =First(Fields!LastName.Value))

To view the report

  1. Click the Preview tab of the report designer.
  2. Click the + icon next to a customer to display order details for that customer.
  3. Click the - icon to hide the details.

OR